In [1]:
In [2]:
In [3]:
Out[3]:
Categories NPS score Importance
0 Happy customers 82 0.263773
1 Transaction issue 16 0.188953
2 App performance issue 22 0.189235
3 Provide cashback and offer 60 0.080175
4 Suggestion 41 0.066789
5 Add new features 56 0.050021
6 Provide prepaid mobile recharge facility 43 0.032126
7 Issue with customer support 28 0.031281
8 UPI pin related 15 0.032267
9 Unable to pay bill 32 0.013245
10 Unable to check balance 13 0.014654
11 Comparision with google pay and phone pay 33 0.010145
12 Allow credit car for payment 42 0.008877
13 Not getting notification/OTP 14 0.007045
14 Unable to scan QR 22 0.004509
15 Provide account statement 57 0.002254
16 Issue with mobile verification 33 0.002536
17 Delay/Cannot apply for IPO 63 0.001127
18 Provide option to send/receive transaction det... -14 0.000986
In [4]:
In [5]:
Out[5]:
Categories NPS score Importance
0 Happy customers 82 0.263773
1 Transaction issue 16 0.188953
2 App performance issue 22 0.189235
3 Provide cashback and offer 60 0.080175
4 Suggestion 41 0.066789
5 Add new features 56 0.050021
6 Provide prepaid mobile recharge facility 43 0.032126
7 Issue with customer support 28 0.031281
8 UPI pin related 15 0.032267
9 Unable to pay bill 32 0.013245
10 Unable to check balance 13 0.014654
11 Comparision with google pay and phone pay 33 0.010145
12 Allow credit car for payment 42 0.008877
13 Not getting notification/OTP 14 0.007045
14 Unable to scan QR 22 0.004509
15 Provide account statement 57 0.002254
16 Issue with mobile verification 33 0.002536
17 Delay/Cannot apply for IPO 63 0.001127
18 Provide option to send/receive transaction det... -14 0.000986

calculating and extraction data for NPS quad

In [6]:
In [7]:
Out[7]:
Categories NPS score Importance Imp in per
0 Happy customers 82 0.263773 26.377343
1 Transaction issue 16 0.188953 18.895308
2 App performance issue 22 0.189235 18.923489
3 Provide cashback and offer 60 0.080175 8.017472
4 Suggestion 41 0.066789 6.678878
5 Add new features 56 0.050021 5.002114
6 Provide prepaid mobile recharge facility 43 0.032126 3.212625
7 Issue with customer support 28 0.031281 3.128082
8 UPI pin related 15 0.032267 3.226716
9 Unable to pay bill 32 0.013245 1.324503
10 Unable to check balance 13 0.014654 1.465408
11 Comparision with google pay and phone pay 33 0.010145 1.014513
12 Allow credit car for payment 42 0.008877 0.887699
13 Not getting notification/OTP 14 0.007045 0.704523
14 Unable to scan QR 22 0.004509 0.450895
15 Provide account statement 57 0.002254 0.225447
16 Issue with mobile verification 33 0.002536 0.253628
17 Delay/Cannot apply for IPO 63 0.001127 0.112724
18 Provide option to send/receive transaction det... -14 0.000986 0.098633
In [8]:

graph using matplotlib

In [9]:
In [10]:
In [11]:
In [12]:
In [13]:
In [14]:
In [15]:
In [16]:

using plotly

In [17]:
In [17]:
In [18]:
In [19]:
Out[19]:
sepal_length sepal_width petal_length petal_width species species_id
0 5.1 3.5 1.4 0.2 setosa 1
1 4.9 3.0 1.4 0.2 setosa 1
2 4.7 3.2 1.3 0.2 setosa 1
3 4.6 3.1 1.5 0.2 setosa 1
4 5.0 3.6 1.4 0.2 setosa 1
... ... ... ... ... ... ...
145 6.7 3.0 5.2 2.3 virginica 3
146 6.3 2.5 5.0 1.9 virginica 3
147 6.5 3.0 5.2 2.0 virginica 3
148 6.2 3.4 5.4 2.3 virginica 3
149 5.9 3.0 5.1 1.8 virginica 3

150 rows × 6 columns

In [20]:
Out[20]:
Categories NPS score Importance Imp in per
0 Happy customers 82 0.263773 26.377343
1 Transaction issue 16 0.188953 18.895308
2 App performance issue 22 0.189235 18.923489
3 Provide cashback and offer 60 0.080175 8.017472
4 Suggestion 41 0.066789 6.678878
5 Add new features 56 0.050021 5.002114
6 Provide prepaid mobile recharge facility 43 0.032126 3.212625
7 Issue with customer support 28 0.031281 3.128082
8 UPI pin related 15 0.032267 3.226716
9 Unable to pay bill 32 0.013245 1.324503
10 Unable to check balance 13 0.014654 1.465408
11 Comparision with google pay and phone pay 33 0.010145 1.014513
12 Allow credit car for payment 42 0.008877 0.887699
13 Not getting notification/OTP 14 0.007045 0.704523
14 Unable to scan QR 22 0.004509 0.450895
15 Provide account statement 57 0.002254 0.225447
16 Issue with mobile verification 33 0.002536 0.253628
17 Delay/Cannot apply for IPO 63 0.001127 0.112724
18 Provide option to send/receive transaction det... -14 0.000986 0.098633
In [22]:
821622604156432815321333421422573363-14−200204060800510152025
CategoriesHappy customersTransaction issueApp performance issue Provide cashback and offerSuggestionAdd new featuresProvide prepaid mobile recharge facilityIssue with customer supportUPI pin relatedUnable to pay billUnable to check balanceComparision with google pay and phone payAllow credit car for paymentNot getting notification/OTPUnable to scan QRProvide account statementIssue with mobile verificationDelay/Cannot apply for IPOProvide option to send/receive transaction detailsNPS scoreImp in per
In [23]:
821622604156432815321333421422573363-14−200204060800510152025
CategoriesHappy customersTransaction issueApp performance issue Provide cashback and offerSuggestionAdd new featuresProvide prepaid mobile recharge facilityIssue with customer supportUPI pin relatedUnable to pay billUnable to check balanceComparision with google pay and phone payAllow credit car for paymentNot getting notification/OTPUnable to scan QRProvide account statementIssue with mobile verificationDelay/Cannot apply for IPOProvide option to send/receive transaction detailsNPS scoreImp in per
In [ ]: